﻿USE [uvp]
GO
/****** 对象:  Table [dbo].[M_UploadData]    脚本日期: 10/14/2012 18:32:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[M_UploadData](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[EquipMac] [nvarchar](50) NOT NULL,
	[FileName] [nvarchar](50) NOT NULL,
	[Size] [numeric](18, 2) NULL,
	[FilePath] [nvarchar](200) NULL,
	[Status] [tinyint] NULL,
	[Memo] [nvarchar](max) NULL,
 CONSTRAINT [PK_M_UploadData] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'设备mac地址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'M_UploadData', @level2type=N'COLUMN',@level2name=N'EquipMac'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'上传文件名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'M_UploadData', @level2type=N'COLUMN',@level2name=N'FileName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'文件保存的全路径' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'M_UploadData', @level2type=N'COLUMN',@level2name=N'FilePath'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'10:上传成功 20:导入成功' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'M_UploadData', @level2type=N'COLUMN',@level2name=N'Status'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'操作记录信息' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'M_UploadData', @level2type=N'COLUMN',@level2name=N'Memo'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用于保存上传的SD卡数据文件记录，便于用户作导入数据的动作。' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'M_UploadData'